public with sharing class DealerContractPrintController {
	///合同id 
	public String conid {get;private set;}
    public String html {get;set;}

    public List<List<ExcelBean>> exList ;
	///合同产品List
	public List<ContractProduct__c> cpList {get;private set;}



    public DealerContractPrintController() {
        exList = new List<List<ExcelBean>>();
    	conid = System.currentPageReference().getParameters().get('cid');
    	getCpList();
        getTable();
        setTableData();

        
    }
    public void getTable(){

       html = '';
       html = '<table border="1" cellpadding="0" cellspacing="0" >';
       for (List<ExcelBean> exl : exList) {
         html += '<tr >'; 

            for (ExcelBean eb: exl ) {
                html += '<td';
                if(eb.style != null  && eb.style != '') html += ' style=' + eb.style ;
                if(eb.colspan != null  && eb.colspan != '') html += ' colspan='+eb.colspan;
                if(eb.rowspan != null  && eb.rowspan != '') html += ' rowspan=' +eb.rowspan;
                html += ' >';
                if(eb.title != null) html += eb.title;

                html += '</td>';
            }
         html += '</tr >'; 

        //html = EncodingUtil.urlEncode(html , 'UTF-8');

           
       }
     /*  html += '<colgroup span="5"></colgroup>';
       html += '<thead class="">';
       html += '<tr style="text-align:center;height:30px;vertical-align:middle;">'; 
       html += '<th colspan="1" >货号</th>';
       html += '<th colspan="1" >产品名称</th>';
       html += '<th colspan="3" >品牌</th>';
       html += '</tr>'; 
       html += '</thead>';

       html += '<tbody >';
       html += '<tr style="text-align:center;height:30px;vertical-align:middle;">'; 
       html += '<td style="width:200px">1111</td>';
       html += '<td style="width:200px">1111</td>';

       html += '<td style="width:200px">1111</td>';

       html += '<td style="width:200px">1111</td>';

       html += '</tr>'; 

        html += '<tr style="text-align:center;height:30px;vertical-align:middle;">'; 
       html += '<td >222</td>';
       html += '<td>1221</td>';

       html += '<td>1221</td>';

       html += '<td>1221</td>';

       html += '</tr>'; 
       html += '</tbody >';*/
        html += '</table >';


    }

    public void setTableData(){
        String jsonData = '[[{"colspan":1,"rowspan":2,"style":{"width":"40px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"类型"},{"colspan":1,"rowspan":2,"style":{"width":"40px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"序号"},{"colspan":1,"rowspan":2,"style":{"width":"210px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"可开展项目"},{"colspan":1,"rowspan":2,"style":{"width":"80px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"存货代码"},{"colspan":1,"rowspan":2,"style":{"width":"90px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"品牌"},{"colspan":1,"rowspan":2,"style":{"width":"50px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"销售费用比例"},{"colspan":1,"rowspan":2,"style":{"width":"50px","color":"","height":"50px","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"测试数"},{"colspan":1,"rowspan":2,"style":{"width":"70px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"标准报价（含税）"},{"colspan":1,"rowspan":2,"style":{"width":"40px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"客户折扣"},{"colspan":1,"rowspan":2,"style":{"width":"100px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"客户价格（含税）"},{"colspan":1,"rowspan":2,"style":{"width":"100px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"经理价格（含税）"},{"colspan":1,"rowspan":2,"style":{"width":"40px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"税率"},{"colspan":1,"rowspan":2,"style":{"width":"40px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"客户每测试价"},{"colspan":2,"rowspan":1,"style":{"width":"150px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"第1年"},{"colspan":2,"rowspan":1,"style":{"width":"150px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"第2年"},{"colspan":2,"rowspan":1,"style":{"width":"150px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"第3年"},{"colspan":2,"rowspan":1,"style":{"width":"150px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"第4年"},{"colspan":2,"rowspan":1,"style":{"width":"150px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"第5年"},{"colspan":2,"rowspan":1,"style":{"width":"150px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"总计"},{"colspan":1,"rowspan":2,"style":{"width":"50px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"产品毛利率"},{"colspan":1,"rowspan":2,"style":{"width":"50px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"经销商折扣"},{"colspan":1,"rowspan":2,"style":{"width":"70px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"经销商每包装成本"},{"colspan":1,"rowspan":2,"style":{"width":"50px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"每测试成本"},{"colspan":1,"rowspan":2,"style":{"width":"70px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"第1年成本"},{"colspan":1,"rowspan":2,"style":{"width":"70px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"第2年成本"},{"colspan":1,"rowspan":2,"style":{"width":"70px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"第3年成本"},{"colspan":1,"rowspan":2,"style":{"width":"70px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"第4年成本"},{"colspan":1,"rowspan":2,"style":{"width":"70px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"第5年成本"},{"colspan":1,"rowspan":2,"style":{"width":"90px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"总成本"}],[{"colspan":1,"rowspan":1,"style":{"width":"","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"标本量(TS)"},{"colspan":1,"rowspan":1,"style":{"width":"","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"销售额"},{"colspan":1,"rowspan":1,"style":{"width":"","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"标本量(TS)"},{"colspan":1,"rowspan":1,"style":{"width":"","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"销售额"},{"colspan":1,"rowspan":1,"style":{"width":"","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"标本量(TS)"},{"colspan":1,"rowspan":1,"style":{"width":"","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"销售额"},{"colspan":1,"rowspan":1,"style":{"width":"","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"标本量(TS)"},{"colspan":1,"rowspan":1,"style":{"width":"","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"销售额"},{"colspan":1,"rowspan":1,"style":{"width":"","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"标本量(TS)"},{"colspan":1,"rowspan":1,"style":{"width":"","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"销售额"},{"colspan":1,"rowspan":1,"style":{"width":"","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"标本量(TS)"},{"colspan":1,"rowspan":1,"style":{"width":"","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"总销售额"}],[{"colspan":6,"rowspan":1,"style":{"width":"","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"现有项目合计"},{"colspan":1,"rowspan":1,"style":{"width":"","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":""},{"colspan":1,"rowspan":1,"style":{"width":"","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":""},{"colspan":1,"rowspan":1,"style":{"width":"","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":""},{"colspan":1,"rowspan":1,"style":{"width":"","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":""},{"colspan":1,"rowspan":1,"style":{"width":"","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":""},{"colspan":1,"rowspan":1,"style":{"width":"","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":""},{"colspan":1,"rowspan":1,"style":{"width":"","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":""},{"colspan":1,"rowspan":1,"style":{"width":"","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"3000"},{"colspan":1,"rowspan":1,"style":{"width":"","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"25000"},{"colspan":1,"rowspan":1,"style":{"width":"","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"3150"},{"colspan":1,"rowspan":1,"style":{"width":"","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"26250"},{"colspan":1,"rowspan":1,"style":{"width":"","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"3308"},{"colspan":1,"rowspan":1,"style":{"width":"","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"27563"},{"colspan":1,"rowspan":1,"style":{"width":"","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"3473"},{"colspan":1,"rowspan":1,"style":{"width":"","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"28941"},{"colspan":1,"rowspan":1,"style":{"width":"","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"3647"},{"colspan":1,"rowspan":1,"style":{"width":"","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"30388"},{"colspan":1,"rowspan":1,"style":{"width":"","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"16577"},{"colspan":1,"rowspan":1,"style":{"width":"","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"138141"},{"colspan":1,"rowspan":1,"style":{"width":"","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":""},{"colspan":1,"rowspan":1,"style":{"width":"","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":""},{"colspan":1,"rowspan":1,"style":{"width":"","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":""},{"colspan":1,"rowspan":1,"style":{"width":"","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":""},{"colspan":1,"rowspan":1,"style":{"width":"","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"25900"},{"colspan":1,"rowspan":1,"style":{"width":"","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"27195"},{"colspan":1,"rowspan":1,"style":{"width":"","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"28555"},{"colspan":1,"rowspan":1,"style":{"width":"","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"29982"},{"colspan":1,"rowspan":1,"style":{"width":"","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"31482"},{"colspan":1,"rowspan":1,"style":{"width":"","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"143114"}],[{"colspan":6,"rowspan":1,"style":{"width":"","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"含预计项目合计"},{"colspan":1,"rowspan":1,"style":{"width":"","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":""},{"colspan":1,"rowspan":1,"style":{"width":"","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":""},{"colspan":1,"rowspan":1,"style":{"width":"","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":""},{"colspan":1,"rowspan":1,"style":{"width":"","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":""},{"colspan":1,"rowspan":1,"style":{"width":"","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":""},{"colspan":1,"rowspan":1,"style":{"width":"","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":""},{"colspan":1,"rowspan":1,"style":{"width":"","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":""},{"colspan":1,"rowspan":1,"style":{"width":"","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"3000"},{"colspan":1,"rowspan":1,"style":{"width":"","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"25000"},{"colspan":1,"rowspan":1,"style":{"width":"","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"3150"},{"colspan":1,"rowspan":1,"style":{"width":"","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"26250"},{"colspan":1,"rowspan":1,"style":{"width":"","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"3308"},{"colspan":1,"rowspan":1,"style":{"width":"","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"27563"},{"colspan":1,"rowspan":1,"style":{"width":"","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"3473"},{"colspan":1,"rowspan":1,"style":{"width":"","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"28941"},{"colspan":1,"rowspan":1,"style":{"width":"","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"3647"},{"colspan":1,"rowspan":1,"style":{"width":"","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"30388"},{"colspan":1,"rowspan":1,"style":{"width":"","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"16577"},{"colspan":1,"rowspan":1,"style":{"width":"","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"138141"},{"colspan":1,"rowspan":1,"style":{"width":"","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":""},{"colspan":1,"rowspan":1,"style":{"width":"","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":""},{"colspan":1,"rowspan":1,"style":{"width":"","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":""},{"colspan":1,"rowspan":1,"style":{"width":"","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":""},{"colspan":1,"rowspan":1,"style":{"width":"","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"25900"},{"colspan":1,"rowspan":1,"style":{"width":"","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"27195"},{"colspan":1,"rowspan":1,"style":{"width":"","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"28555"},{"colspan":1,"rowspan":1,"style":{"width":"","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"29982"},{"colspan":1,"rowspan":1,"style":{"width":"","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"31482"},{"colspan":1,"rowspan":1,"style":{"width":"","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"143114"}],[{"colspan":1,"rowspan":1,"style":{"width":"40px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"center","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"现有"},{"colspan":1,"rowspan":1,"style":{"width":"40px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"center","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"1"},{"colspan":1,"rowspan":1,"style":{"width":"210px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"center","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"凝血酶时间测定试剂盒(凝固法)"},{"colspan":1,"rowspan":1,"style":{"width":"80px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"center","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"BL2109003"},{"colspan":1,"rowspan":1,"style":{"width":"90px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"center","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"四川迈克"},{"colspan":1,"rowspan":1,"style":{"width":"50px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"right","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"5%"},{"colspan":1,"rowspan":1,"style":{"width":"50px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"100.00"},{"colspan":1,"rowspan":1,"style":{"width":"70px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"right","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"901"},{"colspan":1,"rowspan":1,"style":{"width":"40px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"0.55"},{"colspan":1,"rowspan":1,"style":{"width":"100px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"500.00"},{"colspan":1,"rowspan":1,"style":{"width":"100px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"right","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":""},{"colspan":1,"rowspan":1,"style":{"width":"40px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"0.00"},{"colspan":1,"rowspan":1,"style":{"width":"40px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"5"},{"colspan":1,"rowspan":1,"style":{"width":"73px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"1000"},{"colspan":1,"rowspan":1,"style":{"width":"73px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"5000"},{"colspan":1,"rowspan":1,"style":{"width":"73px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"1050"},{"colspan":1,"rowspan":1,"style":{"width":"73px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"5250"},{"colspan":1,"rowspan":1,"style":{"width":"73px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"1103"},{"colspan":1,"rowspan":1,"style":{"width":"73px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"5513"},{"colspan":1,"rowspan":1,"style":{"width":"73px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"1158"},{"colspan":1,"rowspan":1,"style":{"width":"73px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"5788"},{"colspan":1,"rowspan":1,"style":{"width":"73px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"1216"},{"colspan":1,"rowspan":1,"style":{"width":"73px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"6078"},{"colspan":1,"rowspan":1,"style":{"width":"73px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"5526"},{"colspan":1,"rowspan":1,"style":{"width":"73px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"27628"},{"colspan":1,"rowspan":1,"style":{"width":"50px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"-78%"},{"colspan":1,"rowspan":1,"style":{"width":"50px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"0.99"},{"colspan":1,"rowspan":1,"style":{"width":"70px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"right","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"890.00"},{"colspan":1,"rowspan":1,"style":{"width":"50px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"8.9"},{"colspan":1,"rowspan":1,"style":{"width":"70px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"8900"},{"colspan":1,"rowspan":1,"style":{"width":"70px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"9345"},{"colspan":1,"rowspan":1,"style":{"width":"70px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"9812.25"},{"colspan":1,"rowspan":1,"style":{"width":"70px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"10302.86"},{"colspan":1,"rowspan":1,"style":{"width":"70px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"10818.01"},{"colspan":1,"rowspan":1,"style":{"width":"90px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"49178.12"}],[{"colspan":1,"rowspan":1,"style":{"width":"40px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"center","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"现有"},{"colspan":1,"rowspan":1,"style":{"width":"40px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"center","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"2"},{"colspan":1,"rowspan":1,"style":{"width":"210px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"center","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"抗酸杆菌染色试剂盒(抗酸染色法)"},{"colspan":1,"rowspan":1,"style":{"width":"80px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"center","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"OT3101002"},{"colspan":1,"rowspan":1,"style":{"width":"90px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"center","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"四川迈克"},{"colspan":1,"rowspan":1,"style":{"width":"50px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"right","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"5%"},{"colspan":1,"rowspan":1,"style":{"width":"50px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"100.00"},{"colspan":1,"rowspan":1,"style":{"width":"70px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"right","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"904"},{"colspan":1,"rowspan":1,"style":{"width":"40px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"1.11"},{"colspan":1,"rowspan":1,"style":{"width":"100px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"1000.00"},{"colspan":1,"rowspan":1,"style":{"width":"100px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"right","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":""},{"colspan":1,"rowspan":1,"style":{"width":"40px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"0.00"},{"colspan":1,"rowspan":1,"style":{"width":"40px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"10"},{"colspan":1,"rowspan":1,"style":{"width":"73px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"1000"},{"colspan":1,"rowspan":1,"style":{"width":"73px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"10000"},{"colspan":1,"rowspan":1,"style":{"width":"73px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"1050"},{"colspan":1,"rowspan":1,"style":{"width":"73px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"10500"},{"colspan":1,"rowspan":1,"style":{"width":"73px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"1103"},{"colspan":1,"rowspan":1,"style":{"width":"73px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"11025"},{"colspan":1,"rowspan":1,"style":{"width":"73px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"1158"},{"colspan":1,"rowspan":1,"style":{"width":"73px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"11576"},{"colspan":1,"rowspan":1,"style":{"width":"73px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"1216"},{"colspan":1,"rowspan":1,"style":{"width":"73px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"12155"},{"colspan":1,"rowspan":1,"style":{"width":"73px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"5526"},{"colspan":1,"rowspan":1,"style":{"width":"73px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"55256"},{"colspan":1,"rowspan":1,"style":{"width":"50px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"20%"},{"colspan":1,"rowspan":1,"style":{"width":"50px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"0.88"},{"colspan":1,"rowspan":1,"style":{"width":"70px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"right","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"800.00"},{"colspan":1,"rowspan":1,"style":{"width":"50px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"8"},{"colspan":1,"rowspan":1,"style":{"width":"70px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"8000"},{"colspan":1,"rowspan":1,"style":{"width":"70px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"8400"},{"colspan":1,"rowspan":1,"style":{"width":"70px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"8820"},{"colspan":1,"rowspan":1,"style":{"width":"70px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"9261"},{"colspan":1,"rowspan":1,"style":{"width":"70px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"9724.05"},{"colspan":1,"rowspan":1,"style":{"width":"90px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"44205.05"}],[{"colspan":1,"rowspan":1,"style":{"width":"40px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"center","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"现有"},{"colspan":1,"rowspan":1,"style":{"width":"40px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"center","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"3"},{"colspan":1,"rowspan":1,"style":{"width":"210px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"center","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"血细胞染色液试剂(瑞氏染色法)"},{"colspan":1,"rowspan":1,"style":{"width":"80px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"center","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"OT3102003"},{"colspan":1,"rowspan":1,"style":{"width":"90px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"center","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"四川迈克"},{"colspan":1,"rowspan":1,"style":{"width":"50px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"right","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"5%"},{"colspan":1,"rowspan":1,"style":{"width":"50px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"100.00"},{"colspan":1,"rowspan":1,"style":{"width":"70px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"right","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"902"},{"colspan":1,"rowspan":1,"style":{"width":"40px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"1.11"},{"colspan":1,"rowspan":1,"style":{"width":"100px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"1000.00"},{"colspan":1,"rowspan":1,"style":{"width":"100px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"right","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":""},{"colspan":1,"rowspan":1,"style":{"width":"40px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"0.00"},{"colspan":1,"rowspan":1,"style":{"width":"40px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"10"},{"colspan":1,"rowspan":1,"style":{"width":"73px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"1000"},{"colspan":1,"rowspan":1,"style":{"width":"73px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"10000"},{"colspan":1,"rowspan":1,"style":{"width":"73px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"1050"},{"colspan":1,"rowspan":1,"style":{"width":"73px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"10500"},{"colspan":1,"rowspan":1,"style":{"width":"73px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"1103"},{"colspan":1,"rowspan":1,"style":{"width":"73px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"11025"},{"colspan":1,"rowspan":1,"style":{"width":"73px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"1158"},{"colspan":1,"rowspan":1,"style":{"width":"73px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"11576"},{"colspan":1,"rowspan":1,"style":{"width":"73px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"1216"},{"colspan":1,"rowspan":1,"style":{"width":"73px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"12155"},{"colspan":1,"rowspan":1,"style":{"width":"73px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"5526"},{"colspan":1,"rowspan":1,"style":{"width":"73px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"55256"},{"colspan":1,"rowspan":1,"style":{"width":"50px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"10%"},{"colspan":1,"rowspan":1,"style":{"width":"50px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"1"},{"colspan":1,"rowspan":1,"style":{"width":"70px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"right","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"900.00"},{"colspan":1,"rowspan":1,"style":{"width":"50px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"9"},{"colspan":1,"rowspan":1,"style":{"width":"70px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"9000"},{"colspan":1,"rowspan":1,"style":{"width":"70px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"9450"},{"colspan":1,"rowspan":1,"style":{"width":"70px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"9922.5"},{"colspan":1,"rowspan":1,"style":{"width":"70px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"10418.63"},{"colspan":1,"rowspan":1,"style":{"width":"70px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"10939.56"},{"colspan":1,"rowspan":1,"style":{"width":"90px","color":"","height":"","lineHeight":"","backgroundColor":"","textAlign":"","verticalAlign":"","borderColor":"","border":"","fontSize":"","fontFamily":"","fontWeight":""},"title":"49730.68"}]]';
          html = '';
               html = '<table border="1" cellpadding="0" cellspacing="0" >';

        List<Object> datas = (List<Object> ) JSON.deserializeUntyped(jsonData);

        for (Object row : datas) {
            List<Object> tr = (List<Object>)row ;
                 html += '<tr >'; 
            for (Object  col: tr) {

                Map<String,Object> td= (Map<String,Object>) col;

                html += '<td';
                if(td.get('style')!= null  && td.get('style')!= '') html += ' style=' + String.valueOf(td.get('style'));
                if(td.get('colspan') != null  && td.get('colspan')!= '') html += ' colspan='+String.valueOf(td.get('colspan'));
                if(td.get('rowspan') != null  && td.get('rowspan') != '') html += ' rowspan=' +String.valueOf(td.get('rowspan'));
                html += ' >';
                if(td.get('title') != null) html += td.get('title');

             html += '</td>';

        }
          html += '</tr >'; 


    }
    html += '</table >';
}
    public void getCpList (){

    	cpList = [select Id,Name ,Product__r.Brand__c ,Product__r.Spec__c,Product__r.Model__c,Product__r.Unit__c,
    			Product__r.SerialNo__c,UnitPrice1__c,Taxrate__c,SalesPrice__c 
    			from ContractProduct__c where Contract__c =:conid];
     
        String style = 'width:300px;height:30px;text-align:center;vertical-align:middle';
        String hstyle  = 'color:red;height:30px;font-weight:bold;font-size:22.0pt;background-color:#17ABE5;text-align:center;vertical-align:middle';

            List<ExcelBean>  header1   = new List<ExcelBean>();
            ExcelBean title  = new ExcelBean('合同产品价目表'  ,hstyle);
            title.colspan = '5';

            header1.add(title);
            exList.add(header1);

            List<ExcelBean>  header2   = new List<ExcelBean>();

            ExcelBean xb11 = new ExcelBean('产品名称'  ,style);
            ExcelBean xb22 = new ExcelBean('品牌'  ,style);
            ExcelBean xb33 = new ExcelBean('规格'  ,style);
            ExcelBean xb44 = new ExcelBean('货号'  ,style);
            ExcelBean xb55 = new ExcelBean('单价'  ,style);
            header2.add(xb11);
            header2.add(xb22);
            header2.add(xb33);
            header2.add(xb44);
            header2.add(xb55);
            exList.add(header2);

        for (ContractProduct__c cp  : cpList) {
            List<ExcelBean>  xbl = new List<ExcelBean>();
            ExcelBean xb1 = new ExcelBean(cp.Name ,style);
            ExcelBean xb2 = new ExcelBean(cp.Product__r.Brand__c  ,style);
            ExcelBean xb3 = new ExcelBean(cp.Product__r.Spec__c  ,style);
            ExcelBean xb4 = new ExcelBean(cp.Product__r.SerialNo__c  ,style);
            ExcelBean xb5 = new ExcelBean(String.valueOf(cp.SalesPrice__c)  ,style);
            xbl.add(xb1);
            xbl.add(xb2);
            xbl.add(xb3);
            xbl.add(xb4);
            xbl.add(xb5);
            exList.add(xbl);

        }        
    }

    public class ExcelBean {
        public String title ;
        public String colspan;
        public String rowspan;
        public String style;
        public ExcelBean(String t ,String s){
            title = t;
            style = s;
            colspan = '1';
            rowspan = '1';
        }

    }
}